CSV File Structures (Nominal Ledger Records)
Field |
Type |
Size |
Validation |
Precision |
Import Type |
Nominal Code |
Char |
8 |
Yes |
|
Standard / Extended |
Name |
Char |
60 |
|
|
Standard / Extended |
Yearly Budget (Total of Budgets Months 1-12) |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 1 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 2 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 3 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 4 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 5 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 6 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 7 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 8 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 9 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 10 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 11 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Budget Month 12 |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
Actuals - Bfwd, Months 1-12, Future |
--- |
--- |
|
|
Not Included |
Prior Year Month 1 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 2 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 3 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 4 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 5 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 6 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 7 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 8 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 9 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 10 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 11 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Prior Year Month 12 |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
Include in Quick Ratio? |
--- |
--- |
|
|
Not Included |
Memo |
--- |
--- |
|
|
Not Included |
Related Topics